Tabela PersonDisabilityLevel

Definicja tabeli PersonDisabilityLevel

Name

PersonDisabilityLevel

Code

PersonDisabilityLevel

Comment

tabela która bedzie przechowywac informacje o stopniu niepelno sprawnosci


Lista kolumn tabeli PersonDisabilityLevel

Name

Code

PersonDisabilityLevelID

PersonDisabilityLevelID

PersonID

PersonID

DisabilityLevelID

DisabilityLevelID

Active

Active

StartDT

StartDT

StopDT

StopDT

ICDID

ICDID

Reason

Reason

IssueDT

IssueDT

CancelDT

CancelDT

CancelReason

CancelReason

DocumentNo

DocumentNo

IssuedBy

IssuedBy

StatusID

StatusID

DocumentTypeID

DocumentTypeID


Kolumna PersonDisabilityLevelID tabeli PersonDisabilityLevel

Definicja kolumny PersonDisabilityLevelID tabeli PersonDisabilityLevel

Name

PersonDisabilityLevelID

Code

PersonDisabilityLevelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli PersonDisabilityLevel

Definicja kolumny PersonID tabeli PersonDisabilityLevel

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DisabilityLevelID tabeli PersonDisabilityLevel

Definicja kolumny DisabilityLevelID tabeli PersonDisabilityLevel

Name

DisabilityLevelID

Code

DisabilityLevelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli PersonDisabilityLevel

Definicja kolumny Active tabeli PersonDisabilityLevel

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli PersonDisabilityLevel

Definicja kolumny StartDT tabeli PersonDisabilityLevel

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli PersonDisabilityLevel

Definicja kolumny StopDT tabeli PersonDisabilityLevel

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ICDID tabeli PersonDisabilityLevel

Definicja kolumny ICDID tabeli PersonDisabilityLevel

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

Klucz obcy do tabeli ICD


Kolumna Reason tabeli PersonDisabilityLevel

Definicja kolumny Reason tabeli PersonDisabilityLevel

Name

Reason

Code

Reason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Przyczyna niepelnosprawnosci


Kolumna IssueDT tabeli PersonDisabilityLevel

Definicja kolumny IssueDT tabeli PersonDisabilityLevel

Name

IssueDT

Code

IssueDT

Data Type

DATE

Mandatory

No

Comment

Data wystawienia dokumentu poswiadczajacego niepelnosprawnosc


Kolumna CancelDT tabeli PersonDisabilityLevel

Definicja kolumny CancelDT tabeli PersonDisabilityLevel

Name

CancelDT

Code

CancelDT

Data Type

DATE

Mandatory

No

Comment

Data anulowania dokumentu poswiadczajacego niepelnosprawnosc


Kolumna CancelReason tabeli PersonDisabilityLevel

Definicja kolumny CancelReason tabeli PersonDisabilityLevel

Name

CancelReason

Code

CancelReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Przyczyna anulowania dokumentu poswiadczajacego niepelnosprawnosc


Kolumna DocumentNo tabeli PersonDisabilityLevel

Definicja kolumny DocumentNo tabeli PersonDisabilityLevel

Name

DocumentNo

Code

DocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Numer dokumentu poswiadczajacego niepelnosprawnosc


Kolumna IssuedBy tabeli PersonDisabilityLevel

Definicja kolumny IssuedBy tabeli PersonDisabilityLevel

Name

IssuedBy

Code

IssuedBy

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Osoba wystawiajaca dokumentu poswiadczajacy niepelnosprawnosc


Kolumna StatusID tabeli PersonDisabilityLevel

Definicja kolumny StatusID tabeli PersonDisabilityLevel

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id ze slownika statusów inwalidztwa


Kolumna DocumentTypeID tabeli PersonDisabilityLevel

Definicja kolumny DocumentTypeID tabeli PersonDisabilityLevel

Name

DocumentTypeID

Code

DocumentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id ze slownika typów dokumentów potwierdzajacych niepelnosprawnosc


Lista kluczy tabeli PersonDisabilityLevel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PersonDisabilityLevel

Definicja klucza Identifier_1 tabeli PersonDisabilityLevel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment